SUPPORT / SAMPLES & SAS NOTES
Problem Note 55154: Optimization fails with "ERROR: TKTException code = 6 (Access violation)..."
 |  |  |  |  |
In SAS® Regular Price Optimization, optimization might fail with the following error in the MerchIntelGridSvr.log file:
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - ERROR: TKTException code = 6 (Access violation) <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #4 0x00007f8eaa8ac9cc in tkmi_exception_handler (thread=0x6533, ctxt=0x7f8dc3dcce9c, code=TKTE_UnknownException) at /sas/dev/mva-f4ro52/di/src/tkmi_exception.c:88 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #5 0x00007f8eb6253196 in bktExcept () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #6 0x00007f8eb625619b in bkt_segv () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #7 0x00007f8eb6253764 in bkt_signal_handler () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #8 <signal handler called> <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #9 0x00007f8eaaaea370 in rpo_service_set_unit_volume_flag_and_model_type (rpo_plan=0x7f8c143c0cc6, odf_pg_list=0x7f8eaadada52) at /sas/dev/mva-f4ro52/dipca/src/rpo_service.c:2105 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #10 0x00007f8eaaae8b01 in rpo_service_process_odf_results (rpo_plan=0x7f8c143c0cc6, odf_pg_list=0x7f8eaadada52) at /sas/dev/mva-f4ro52/dipca/src/rpo_service.c:2226 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #11 0x00007f8eaaae3250 in rpo_service_process_plan (plan_sk=100203, request_type=RPO_OPT) at /sas/dev/mva-f4ro52/dipca/src/rpo_service.c:1776 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #12 0x0 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - 20150123:10.25.46.43: 0007f8eaaae27fb in rpo_service_optimize (plan_sk=339479750) at /sas/dev/mva-f4ro52/dipca/src/rpo_service.c:1887 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #13 0x00007f8eaa88b2c8 in run_cmd_internal (cmd=0x7f8c143c0cc6) at /sas/dev/mva-f4ro52/di/src/tkmi.c:1256 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #14 0x00007f8eaa8896ab in run_cmd (cmd=0x7f8dc3cba9b0) at /sas/dev/mva-f4ro52/di/src/tkmi.c:990 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #15 0x00007f8eaa8880d8 in tkmi_run (tkmi_inst=0x7f8c143c0cc6, cmd_string=0x7f8eaadada52 "UNITS", callback_fn=0) at /sas/dev/mva-f4ro52/di/src/tkmi.c:771 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #16 0x00007f8eab0b0748 in miExecuteBridge (exports=0x7f8eaadada52, pool=0x0, parms=0xfac8, returnValue=0x7f8c17e560f0, jnl=0xbc6) at /sas/wky/mva-m4ro52/di/src/tkmibridge.c:102 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #17 0x0000000000408536 in executeFunction () <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #18 0x000000000040721c in clientHandler () <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #19 0x00007f8eb62519a6 in sktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #20 0x00007f8eb6252ffb in bktMain () from /sso/sfw/sas/930/SASFoundation/9.3/sasexe/tkmk.so <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #21 0x0000003124a079d1 in start_thread () from /lib64/libpthread.so.0 <YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG - #22 0x00000031242e8b6d in clone () fro
The failure occurs when the regular price plan contains a new product that is sold only in a noncomparable store and this product does not have estimation results.
The workaround for this issue is to exclude new products only sold in noncomparable stores with no estimation results from regular price plans.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||